<?php
//======================================================================================
//
// Function: Get HUB_IMPORT dasta
//
// Programmer: JKJ
// Date      : 2024-04-22
//
// Copyright Reeft A/S (c) - 2024
//======================================================================================

//======================================================================================
// General config
//======================================================================================
	include "config/config.php";

//======================================================================================
// Get input
//======================================================================================

//======================================================================================
// Get session variables
//======================================================================================
	include "include/getsession.php";

//======================================================================================
// Set language
//======================================================================================
	include "include/set_language.php";

//======================================================================================
// Connect to SQLite database in file
//======================================================================================

	$entries_found					= 0;

	$returnCode 					= '99';
	$returnMsg 						= 'No data found';

	$currentDate = date('Y-m-d');
	$currentTime = date('H:i:s');

//======================================================================================
// Set header
//======================================================================================

	header('Content-Type: application/json;charset=utf-8');

//======================================================================================
// Connect to some DB
//======================================================================================
	include "include/db_connect.php";

//======================================================================================
// Create SQL
//======================================================================================

	$sql = "SELECT * FROM visual_department";

//======================================================================================
// Get data
//======================================================================================
	include "include/db_run_sql.php";

//======================================================================================
// Init
//======================================================================================
	$aryDetail = array();


	foreach( $data as $row )
    {

		$tmpRow = array();

		// visual_order_header
		$tmpRow["pk_department"]		= $row["pk_department"];
		$tmpRow["department_code"]		= $row["department_code"];
		$tmpRow["department_name"]		= $row["department_name"];
		$tmpRow["department_image"]		= $row["department_image"];
		$tmpRow["department_color"]		= $row["department_color"];
		$tmpRow["department_active"]	= $row["department_active"];

		$returnCode 			= '00';
		$returnMsg 				= 'Alles ist gut';

		$entries_found++;

		// Add to array
        $aryDetail[] = $tmpRow;

	}


	// Create header
	$aryHeader = array();
	$aryHeader["entries_found"] = $entries_found;
	$aryHeader["currentDate"] 	= $currentDate;
	$aryHeader["currentTime"] 	= $currentTime;
	$aryHeader["returnCode"] 	= $returnCode;
	$aryHeader["returnMsg"] 	= $returnMsg;
	$aryHeader["database_used"] = $DFT_DATABASE_TO_USE;

	// Create array and prepare for json encoding
	$returnJson["header"] 		= $aryHeader;
	$returnJson["detail"] 		= $aryDetail;

//======================================================================================
// Paint it black
//======================================================================================
    echo(json_encode($returnJson));

?>